SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431438 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431438 [ RunTime:0.002219s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412525,319700,536840,348028,553033,518412,869288,886371,627798,724016,519789,165290,47850,1048502,650498,510537,616191,203557,941941,769447,20986,1012435,1016254,860788,418652,122738,703293,484363,173092,557280,275653,622518,443865,232990,300056,600319,611647,105486,226254,982957,516439,444377,684994,883442,565509,358364,352339,485080,426802,63188,375521,227869,662416,401017,246871,103017,323683,603750,89542,344775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]