SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520388 LIMIT 1 [ RunTime:0.001293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520388 [ RunTime:0.008381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992013,119343,465733,953536,686744,289336,657024,724541,398062,746356,44648,206343,632646,341770,288284,998134,222435,30468,786792,541603,112155,971285,98376,743549,170433,1000079,299437,182065,707835,235012,276123,451173,754880,356741,104815,405785,52810,631115,448946,131377,276716,614041,194069,257946,551281,439229,27615,354526,780507,440183,981166,534440,649120,717353,987546,181515,735094,691793,363896,331872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520388 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520388 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001373s ]