SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 962871 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 962871 [ RunTime:0.005210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120389,330843,888022,208862,61322,831948,485444,520407,1008623,53881,587553,594983,674859,829940,128061,410629,1002924,190290,326707,813080,15568,422937,504256,881733,314670,780310,503923,18789,711606,34571,1562,116724,221831,868406,47499,794008,472720,384255,556501,131143,362285,373609,307215,281787,215823,859176,274798,614394,167067,166180,685770,669406,893264,80114,74780,872326,667012,279282,851480,717947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 962871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 962871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001708s ]