SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201087 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201087 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517952,656733,865368,513022,373394,838912,411253,823103,738130,913025,85223,890439,134166,821672,336119,1015128,963743,933789,819760,568725,157591,793268,627847,829630,856564,179475,80484,502443,471934,57614,801236,830768,590830,588796,964708,42679,325606,613334,698150,826583,591410,1019956,803849,713123,271683,88540,445633,873668,608914,588797,395699,428175,14524,442083,676392,958228,634549,406919,218860,8610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]