SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417249 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417249 [ RunTime:0.002714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868553,907610,292916,378949,289755,1005447,558718,559812,467161,480289,967695,715265,198041,817393,45524,604689,16336,755152,803851,474351,811614,927558,1019850,184546,964947,447291,898170,306210,51361,8788,935884,662378,332,73977,879532,340108,478081,263313,944018,519992,991680,231947,412833,600978,255667,371509,962602,1045561,468602,616878,862835,999569,268034,871625,488166,894966,73612,971320,622893,724189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417249 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417249 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]