SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004556s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514535 LIMIT 1 [ RunTime:0.002551s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514535 [ RunTime:0.005821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591099,90831,343309,353718,893692,458939,880953,1015961,688129,315169,795003,242837,277220,970168,296395,743937,253132,903443,646851,899468,506071,59747,764193,655956,704118,717727,339828,713105,263188,755140,431524,842937,496194,1034509,230314,284542,423457,177650,90493,703789,392808,380574,332316,539300,347071,312057,908670,390183,628649,605913,38030,145908,1013609,907711,666037,354540,30745,958985,934122,479660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]