SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511261 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511261 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438974,275410,525901,875418,547460,253855,488965,328168,6972,747191,66317,398427,258994,734118,868497,1024444,632241,536781,844727,559066,822836,462188,135752,574891,243195,564811,81025,747337,530439,744176,189497,760234,78638,483523,521578,678205,396950,826501,166694,602631,1019140,574246,396467,303144,624533,348749,107205,39627,125815,631114,196794,135101,905074,9443,792872,71462,403505,214309,757499,775662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511261 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511261 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]