SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519719 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519719 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53400,869053,33842,119151,458149,1016296,560161,88182,763438,150183,204689,421338,746500,191983,764760,71950,4060,1002301,572252,386886,930020,349616,226211,933937,555710,539668,547149,403984,388615,546209,1042247,356123,106903,802883,330541,620069,540181,146479,325099,710691,297778,488556,749220,691009,587143,977411,370732,607764,652481,240040,792268,101369,733466,747180,249347,52634,633729,995774,130649,88904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519719 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519719 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]