SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197043 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197043 [ RunTime:0.003103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610270,586732,485969,203488,602431,572367,263905,953249,601155,891258,71134,445175,678662,465373,1010872,313659,238341,269331,344766,947999,911428,81871,802109,926999,857334,69591,980676,359642,159628,197830,350422,258564,246055,761852,961500,25529,417260,484667,43422,110516,548067,760543,710522,401516,553981,616640,854902,889747,788896,177204,869089,703780,1040297,143951,788204,540033,321277,261841,108357,740274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003988s ]