SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003510s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109207 LIMIT 1 [ RunTime:0.000832s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109207 [ RunTime:0.004064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349773,786740,289478,378301,90533,351492,718257,66480,219487,1036342,1003506,683841,986067,508721,961520,6676,324932,884761,866537,499502,838143,377376,757041,1027241,228313,333539,362293,405565,264359,829614,32588,665270,595686,3275,421949,5134,535184,227173,742012,837692,752596,326053,238409,423120,683986,537282,635674,1016471,1043369,385879,388594,295917,658645,536504,357975,598722,970667,27900,500194,545289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]