SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540499 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540499 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407284,984570,103714,322157,172840,199617,646433,458988,589057,60857,631696,107613,411099,752064,54198,540294,731425,228389,1006622,583570,718143,275099,946051,379747,437172,120899,167281,966964,3456,744285,110289,1043478,265392,703198,275828,183805,833038,601787,423839,467832,988280,27959,204111,759603,720047,1007759,264968,465665,1045958,92156,1026035,233610,724116,214012,253948,216082,269367,354679,824605,852205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]