SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026590 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026590 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112519,594199,569883,262649,354902,931541,342609,223120,797521,1008424,883781,961174,943955,202630,379189,475062,250143,673441,607115,199580,28882,744696,966439,225385,25904,934930,716576,702529,576327,623374,201936,15682,897220,878658,168879,512089,655410,141115,679317,641696,743559,942354,525494,159238,934732,74367,830989,858857,885709,589952,604051,311096,759059,102338,67369,814664,356684,999167,128277,257818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]