SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508608 LIMIT 1 [ RunTime:0.000839s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508608 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44860,820304,875579,100730,634136,932730,174234,842674,861240,827665,307504,883426,557251,1007643,530710,1014559,445002,967759,496005,144256,1022946,599937,287686,971937,992384,30908,518675,393690,636001,345891,1026085,471079,124622,323511,560069,295896,727709,935903,1033390,624183,809767,990066,467437,660326,630246,833421,547314,67790,136594,1046291,52186,496440,918601,840678,448940,198399,727334,948340,237422,132781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]