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` = 439541 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439541 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191513,738570,605507,808675,261199,643965,1030445,392194,493138,515244,544274,406961,982001,915107,344146,756668,673397,766691,863118,108179,286152,9522,933789,901499,631960,73524,816643,469009,393797,494461,503179,989972,846973,275251,137955,900597,1007253,39778,455586,759822,94473,119334,174568,516224,950275,904717,127529,150247,509640,381336,630440,608310,875546,798734,77407,997092,302538,572766,613012,971860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]