SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532603 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532603 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692335,870688,402078,1004967,222928,93322,288568,417103,533986,923915,646384,506809,883225,336677,879014,1022689,778729,197175,427908,294029,28641,170837,673415,900320,601436,391603,196298,204038,439969,396913,114785,937406,1004824,705609,77071,987533,811974,413166,622117,219560,684102,554142,136072,760163,594875,245972,368929,974288,762963,953374,438911,257838,986305,427974,380996,253739,1048536,474128,1042730,753908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]