SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476820 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476820 [ RunTime:0.004428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975686,673125,686100,400271,30370,943189,111064,566240,532780,550405,2794,204100,9474,963373,887672,742762,505485,932617,754958,481623,148042,582950,884232,907931,98062,379176,252560,780892,433127,342108,481443,101617,145851,84571,560267,927918,971777,501938,302896,578018,157425,504882,1013516,736178,43813,179405,74549,891231,149740,647780,372781,137237,943860,44003,405343,613663,330357,103610,893151,1007662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]