SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423910 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423910 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520128,501268,637448,109602,945052,821907,66756,54963,925237,754983,501628,899251,1002299,1032542,24315,391335,830763,65915,89082,171948,640057,980928,222828,1010066,204915,652323,337368,971354,679104,566986,216591,433723,20470,82610,755821,843539,39337,337962,202068,575666,837918,891676,97919,982837,294577,569287,314442,978029,281389,522606,601487,553898,472435,792335,296327,310511,1045225,760957,856060,356351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]