SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311619 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311619 [ RunTime:0.002252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282097,604585,1042667,597250,928657,482902,899606,328800,329371,1041533,399050,880487,506176,323516,902624,125715,422233,739364,234229,760825,925905,454839,1044994,745739,413287,602049,392657,681434,38082,159417,467396,662230,976865,485411,136256,701401,592408,943349,521315,332995,278221,290130,321734,242602,550411,185389,151825,331136,416810,276436,931730,608928,816380,735290,33910,492506,839069,130838,724560,1003184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311619 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311619 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]