SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198473 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198473 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522275,286197,188872,660098,228900,167067,646164,137680,179762,546157,580304,890555,480597,839869,410434,6243,213784,689019,653878,164059,962391,419021,3689,816721,615231,500461,453682,902731,1021888,517810,8866,60935,353931,1003036,215573,257192,1010704,651839,1031807,117184,842106,829491,514123,135738,353441,337623,550321,746905,117241,229463,314787,902660,556471,689698,1016827,437592,1026185,429567,365891,188565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]