SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520489 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520489 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399212,967246,847518,140883,709591,660640,775976,925265,624843,538300,649337,358760,805027,820473,916611,639976,859217,56619,31850,735773,964845,50407,167407,154464,600272,208377,954940,935082,256148,464131,928787,121372,1002777,625695,525634,11423,486965,503618,733493,724156,940406,289041,304521,529364,117510,405299,63996,308913,178292,890304,925379,511402,350224,193820,795921,1009448,713934,423872,266276,602305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]