SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382073 LIMIT 1 [ RunTime:0.001217s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382073 [ RunTime:0.002528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804578,887909,475152,824312,299981,776367,464549,983802,312010,554304,827807,1035160,629696,521382,17584,741880,179602,196575,417963,996054,792415,101684,493288,8510,603398,208268,36563,320682,1046410,513527,443045,552049,1046190,916639,732526,80336,789662,803837,763251,191629,633925,943116,926428,27237,1046061,363192,581368,617460,451835,132085,484667,909006,354398,20439,829690,596560,535748,124017,964168,64545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]