SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594401 LIMIT 1 [ RunTime:0.000524s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594401 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856042,750962,52700,1028838,631628,203920,375622,822006,308384,168711,545772,205635,425669,545951,292548,311864,992652,78655,881020,896068,670511,494783,74541,840929,914687,373791,74657,1016936,296276,3496,727069,617384,528524,416018,681925,463291,963380,503725,704169,1043132,490408,713072,268110,163661,295940,292604,839568,1007305,764214,653429,98271,872394,584267,508071,125661,946237,240175,509201,162484,463285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]