SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413498 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413498 [ RunTime:0.002516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813800,773259,852016,229547,1039005,354962,734204,631375,958262,23737,247873,336132,212460,10679,263920,325813,109680,451432,524311,802080,195148,1017059,1022801,118938,764304,378462,759059,732322,690484,999535,739130,517413,478117,974999,79641,202909,300246,135043,847269,727911,1020938,31291,942541,1005353,729868,37586,343886,777234,359463,487837,948448,506645,422997,42545,729421,973035,794766,405395,279256,283084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001438s ]