SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414096 LIMIT 1 [ RunTime:0.001321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414096 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108976,531520,824599,240453,1010070,474281,916099,119556,331611,45154,224712,7453,235616,613350,489268,921627,550602,194429,443175,109061,73757,184362,912717,482198,841291,53274,454352,434741,470295,290366,863129,702882,16111,934215,714654,592524,292542,270391,678692,195575,789841,597298,803071,174925,115666,443843,410286,580438,1003637,148810,196646,477206,460136,596171,932830,353999,954226,95620,312049,678160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000994s ]