SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500144 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500144 [ RunTime:0.001479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517571,778780,734671,230558,385565,133432,910777,644581,179562,675023,864851,981127,79062,437344,115693,932228,960477,702405,786278,389024,77588,878620,931864,498810,865753,487669,514781,258948,204815,680617,908732,537778,695108,233328,165419,1021575,667600,86407,31831,471770,455243,70487,928323,915431,941571,149184,422454,448766,836947,1040413,567172,345520,258296,679276,120984,884927,687616,1015677,321079,403137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]