SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 139988 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 139988 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950682,332348,157301,606674,941205,441250,177394,189616,744238,803513,445315,764630,319947,567323,111316,64128,772758,230935,613755,231188,825191,181863,453884,1035206,385774,1043478,516320,718227,682751,321233,683836,228460,138160,954596,972174,94642,192940,62124,238980,759476,806897,941114,73955,782175,548679,404106,111334,656821,728271,768958,499284,51267,860968,225802,1001864,739042,4254,337396,72894,453839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 139988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 139988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]