SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261406 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261406 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37244,915483,91186,200418,171800,732901,978309,417102,136469,479007,261053,170292,874827,994731,897463,115974,574324,457837,433819,437888,320310,662720,904488,980377,80735,993217,664542,48608,824708,760360,503423,305842,715715,790060,127304,211868,368083,646723,326959,10951,188577,200692,61843,848019,970231,10381,712583,609387,886414,833729,402109,11535,275341,418348,575684,155588,407012,367663,112749,934600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]