SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038961 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038961 [ RunTime:0.002048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275095,944848,72430,964275,228631,105221,539640,871734,677793,877791,278864,767086,295120,498353,709672,641453,270904,854388,897095,672009,20393,58501,339352,84404,894987,203772,363727,885111,961976,197649,421146,406681,337339,1017424,513060,194712,235685,855468,397498,507784,276844,946888,869350,704112,830555,838063,895839,843711,454043,467769,877087,111310,276452,379684,98806,192246,775423,604615,808143,368274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]