SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106513 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106513 [ RunTime:0.003276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32503,854295,487178,883737,376369,594436,501212,290950,410251,12971,869091,658163,356144,1012432,36600,42264,171844,562729,890866,808426,574002,442949,882279,499729,735311,485971,261819,705302,23736,439111,565191,876291,11473,183635,930669,429781,12474,510039,345890,837019,445710,973674,408822,46272,181379,229072,968537,1028930,988169,561980,554961,1013300,313060,672241,276285,661189,187519,59310,215354,360802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]