SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564246 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564246 [ RunTime:0.004118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640111,656779,779996,677409,227168,984659,758411,544771,429919,189067,189596,361164,274248,409861,41310,73719,540814,708709,946589,217631,532255,696442,42049,854158,164314,103421,234746,346469,466579,783357,115946,939298,859099,694079,447487,231596,968664,1015900,347278,137988,418082,575166,496078,586260,55299,265451,31722,132686,856436,274340,234748,746295,467812,69880,499246,973162,180362,892008,215250,243245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]