SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310430 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310430 [ RunTime:0.002420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161066,860766,422611,451343,125519,575635,673123,216158,405449,227552,865439,816774,561029,701764,741617,108240,952413,341715,463908,994798,972997,62712,896633,352903,32655,491087,85493,281448,189493,414297,1023890,183644,354498,69873,709213,926014,425461,397485,79800,69602,619098,290578,332883,236536,435865,339085,989656,586000,210410,253601,621193,590775,615754,555068,500441,983825,891213,746672,567375,912597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]