SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445509 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445509 [ RunTime:0.002249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836702,62326,46537,159703,233762,31426,687182,507023,705731,899798,59221,130495,744509,1000807,189182,388348,1002256,471572,142995,143604,777391,63583,33710,995053,370866,737060,602753,47814,495716,455709,770545,507761,139653,195348,440543,942150,825032,477787,71810,686182,427288,548623,895491,784301,388041,175306,664177,971759,347908,975925,645172,852772,346765,133496,126509,138564,694710,98260,709247,953391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]