SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267231 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267231 [ RunTime:0.001354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964915,1025449,268503,130171,533192,446811,874128,394724,823807,862869,400264,21288,212408,432627,668664,258595,477453,1027612,1015243,363247,427527,994947,762816,544377,656359,50040,321484,476560,510133,738102,308416,672538,1037649,253540,1001724,22961,154693,315599,792908,1039122,671338,423098,85721,676388,584604,794143,1018484,982710,456107,69468,655984,668624,717436,147432,158786,395365,883994,747819,247545,279035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001875s ]