SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331093 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331093 [ RunTime:0.003325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879104,1048227,914119,13374,56065,398171,154662,473489,468956,128408,761368,781110,493483,829919,689210,782344,544754,684507,790711,529358,361398,673966,843682,172457,363996,462706,272860,81564,989226,601406,771718,804659,388911,50323,1014138,68116,747023,665144,526967,288432,928213,830382,960660,232241,730274,488263,265396,265614,33614,248222,720964,598257,388079,345203,168213,620390,1005998,366190,818239,782031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]