SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407537 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407537 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678255,829811,439157,442665,940660,391004,972724,821937,176004,230904,158192,924175,811613,1004749,449770,134489,773440,249999,1042999,946876,134021,887484,849316,154612,1046165,93458,492486,1013557,725667,394395,154678,421952,638730,583950,902507,869267,783641,803200,609336,113480,367296,1007125,888901,802404,291005,741813,512814,57250,567118,610974,538051,999573,342190,72320,836696,612377,882647,190098,136897,271216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407537 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407537 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]