SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504048 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504048 [ RunTime:0.002538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405080,593333,878396,934572,51526,380881,619809,687976,883807,1033119,654741,708353,511751,370255,842042,664999,483418,363228,966986,633871,913223,106316,328509,39152,473972,627391,761222,360204,855710,758348,674440,468158,773281,852396,285752,465934,636028,390009,605513,679857,489794,19797,317593,205704,88315,503698,186046,669533,238259,1025611,631034,641736,29355,778328,755274,455166,819165,937722,872515,109895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]