SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003670s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003751 LIMIT 1 [ RunTime:0.000561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003751 [ RunTime:0.002190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215816,501978,100104,622900,255576,948572,140206,135334,679195,519455,222695,1003520,395674,1045865,987492,611535,466419,729999,898932,75324,344234,966388,960805,679102,685191,1037835,105299,795040,35424,761127,926686,76984,1046174,284545,355104,322070,400773,227353,563516,78136,358757,307055,120538,29162,174174,128110,307045,450279,372940,101974,676858,618189,790311,338424,595041,432956,810395,1015107,747471,850452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001021s ]