SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68579 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68579 [ RunTime:0.002945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778921,840412,715564,794112,629851,178276,260346,750984,447463,227117,867405,509774,826174,154001,636336,723023,765665,562144,14819,944331,791817,559054,261755,744101,371259,1025918,950550,509418,804063,884645,559200,663399,933330,265113,984734,427888,336808,161632,321542,659415,713821,1017660,470370,748332,1009960,429847,512585,984569,269525,742147,976145,1036397,164423,720494,623343,667195,228263,435805,377092,258071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68579 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68579 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002457s ]