SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531396 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531396 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497407,582032,63482,456327,672339,418808,963361,986892,860568,315658,948980,258352,129195,993791,964761,367481,173216,600703,918255,29586,202687,306400,256944,224739,422803,890657,979189,694529,549025,194983,143527,1026342,903084,332813,708532,1000168,807376,534707,863726,126780,692143,543647,317582,207905,483471,928250,369264,286663,549336,802056,231698,347942,1024339,281646,587101,559410,520361,785045,363999,997400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]