SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588458 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588458 [ RunTime:0.004927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015974,195432,315218,830302,818815,832569,1008228,918084,967808,913628,31374,87146,118691,53321,75920,726096,123653,977287,209604,446065,42078,843327,325379,692992,310594,255737,497358,646448,400228,951445,823032,471173,752550,176539,761742,40555,939185,738220,675636,330896,743682,434914,708074,403206,1048531,121612,922034,976739,632032,787807,444324,771290,646898,50758,192679,252145,629467,1000262,471212,202368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]