SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416038 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416038 [ RunTime:0.008827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583806,927796,828966,234902,42780,571837,988186,998975,72032,147578,986745,403244,617779,1043076,313957,510070,238277,1010140,831473,941238,197450,461323,567219,163154,494456,575037,849704,225124,826375,997632,404571,961064,441803,920871,932578,286696,608687,543905,554810,580706,616914,772601,49526,716745,123816,305423,204297,871267,783733,193012,859673,1009977,115269,608333,493469,165738,964208,465595,864263,681350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]