SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001547s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34144 LIMIT 1 [ RunTime:0.000877s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34144 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677913,960392,397821,87438,107570,741785,377526,875682,477242,781699,529686,130407,1026594,957569,17288,307969,968325,192316,577635,203300,262028,159669,154017,254970,998032,188338,742916,309568,861795,449590,149627,335214,22043,798641,619925,757349,420536,703050,270997,346684,670349,654032,38815,272981,294692,450511,805882,635399,699911,318760,153063,169350,83492,1024333,745278,451925,211131,30221,933545,904100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000917s ]