SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001925s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982439 LIMIT 1 [ RunTime:0.002902s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982439 [ RunTime:0.002524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536146,198069,895766,756440,519958,857397,464906,1038116,994404,1041902,156369,358378,1047050,540219,16425,101954,26680,426447,804047,608482,990536,1016884,200971,52170,201070,588300,923956,879430,644562,351451,559392,197638,398656,409339,140230,547543,653485,19052,585406,819320,407283,967342,1034897,496890,38205,852994,258249,845387,395912,259777,42457,374128,313546,718419,758096,351818,80814,362650,555509,845862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]