SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105011 LIMIT 1 [ RunTime:0.000793s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105011 [ RunTime:0.005945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109846,510059,568759,541565,905240,1013593,897582,632455,462844,844987,143841,781988,441544,543513,721748,952914,172375,627693,1045264,527931,1002429,932830,93030,417379,637905,780526,110743,392661,310108,224096,846633,507962,1047224,696129,362405,777811,719535,487290,957035,1012141,492555,267361,153749,156985,528729,362362,561271,999704,603730,425435,700334,770006,149410,534376,75331,82488,973222,277256,272785,699349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]