SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502078 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502078 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790095,952760,126252,81560,386007,565913,289255,750561,335201,178848,504505,616095,566793,801670,999977,680396,70039,412435,649011,716400,285755,1032575,122125,892612,328689,517613,941081,407176,891951,405191,849979,950827,122099,460093,342831,146387,944664,502304,653361,335222,889856,459367,155091,750656,818544,833082,213985,269660,173918,947289,718013,99393,448868,155258,76001,121824,291909,174161,539926,522501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]