SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 656816 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 656816 [ RunTime:0.007752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437087,975573,767001,394280,993772,290220,371779,77958,934014,1019587,338003,701341,992640,686548,382853,619424,716464,485014,877101,437776,347073,595158,982292,273970,713596,737039,826540,673138,26675,792718,401695,918659,857057,664349,1020523,691039,644748,540400,985317,484732,336911,831068,803084,1043478,391278,1031034,595390,731405,155549,141779,1042071,299447,151069,423426,673844,190802,588789,333504,103054,287008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 656816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 656816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]