SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323438 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323438 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459682,16594,180212,1011401,350890,316007,957223,683570,324586,332491,1025348,1021651,636337,124503,564224,587846,944623,616681,759144,590189,558338,1041114,863682,575867,595055,1006064,616127,937714,560844,1008901,1003528,256822,617038,429048,279545,877334,410350,92847,127214,875271,262081,24317,86133,42590,717282,85374,829652,846866,167165,524067,77532,317284,955512,778413,999046,77416,308346,397744,39631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]