SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545323 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545323 [ RunTime:0.003466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431343,184092,830522,705177,317033,999792,185142,868660,331750,151763,46474,755465,515638,197178,308006,505042,683789,661644,447974,122486,63421,765451,955405,835525,540651,994396,717408,759361,449962,735783,541475,455568,871792,190850,625340,442997,765036,103397,298235,726342,608597,312221,348192,475602,605298,150840,1027454,819309,86830,9214,292719,763165,252732,980732,899614,1008288,303756,414706,176528,387988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]