SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560512 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560512 [ RunTime:0.006540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242600,905182,921247,426717,528044,161444,316834,759725,18856,716654,831890,711858,1029706,347483,368331,177000,511415,585258,1036146,137406,162542,101063,306946,233305,480881,706422,173361,572524,712555,906586,413059,288374,973082,195289,632034,724753,326773,781660,149926,244015,1004681,791617,623330,953704,959930,1047118,691305,252989,985541,8337,536778,822070,872886,867673,955934,1036004,834708,604346,417449,187795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]