SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041047 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041047 [ RunTime:0.003155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422544,939446,50624,525244,1021894,277808,354159,416017,359542,803063,141637,785136,400844,197742,336684,208038,155513,129629,142060,195735,839682,90626,346692,345925,234047,459510,444823,737448,681569,747283,954782,734563,441770,497649,363286,156906,676745,1020572,908980,913581,889932,703724,280712,669624,432722,127598,636243,366156,713840,784091,402042,530914,943638,996273,700185,877227,739997,152210,709438,234578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002182s ]