SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814580 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814580 [ RunTime:0.002202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440427,293913,270481,375685,498930,432048,780312,851941,373389,683848,664564,36739,112618,848548,789008,234182,36576,386448,663157,11754,150572,475260,896137,411727,349722,433105,19122,463749,267794,612176,66445,940299,691892,138138,366383,1026297,773558,190780,235867,104300,304907,379754,905411,712304,852864,606904,858245,257887,48205,461870,338375,184834,99149,894914,320930,635712,918054,424502,28501,656731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]