SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803110 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803110 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411795,732274,671364,427506,463210,950694,325911,35293,579466,351802,703125,480926,770738,642723,509951,985493,713718,515388,776828,187538,703481,382191,805233,526151,344821,458479,830688,652536,659534,960475,983255,1038226,448794,602506,194848,191292,594002,406657,94666,950984,527982,733624,332299,448202,537822,468779,426714,848436,197888,149688,185294,576507,653315,234832,996869,357780,16329,579642,342088,507907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]