SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294678 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294678 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234297,794739,139149,377668,133903,452028,239123,339129,563560,391646,108407,820792,583213,179835,668694,615106,453313,1007200,608543,477012,597479,507104,879817,454562,807712,731054,607690,497468,554408,222505,950390,866516,527570,188819,691462,509908,400870,289711,17788,598838,506663,687763,1011425,451195,499435,564996,204916,738695,4008,185990,849186,1020625,573533,1039126,393044,892799,886072,994411,223976,579459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000735s ]