SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268071 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268071 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156558,147879,713164,591283,532286,721036,269812,971107,243344,125845,747731,965447,368573,376126,971742,660110,1034361,216119,120926,905549,203560,963418,1011160,289330,647671,930906,1021144,27183,140365,292144,613343,310246,732905,830811,278743,776445,721097,1003266,910887,498858,852097,170224,179175,48832,90136,492250,546879,292451,899464,730325,1046028,367469,258163,163947,801178,873531,334709,248690,285790,149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002741s ]