SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310093 LIMIT 1 [ RunTime:0.000787s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310093 [ RunTime:0.002853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336385,26832,1032127,843258,343079,970188,619579,717386,595624,840386,26237,76172,752109,116721,899425,244041,465488,1027039,992169,484225,325487,839430,509450,350955,393486,498713,660369,685356,77180,387552,988860,555470,136466,921662,81940,114667,522238,899474,769303,910470,624419,760690,136189,5208,488816,134216,913984,1040939,869804,655214,561089,478658,233294,350958,692341,534029,631468,534143,890418,350712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000880s ]