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` = 1027147 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027147 [ RunTime:0.003013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561390,402700,118061,407813,818734,1031299,451503,752350,90177,191473,39834,911249,762522,878570,567204,536353,866304,939296,124440,96343,876969,509674,959718,646196,725744,1046650,870773,188074,364353,652459,484855,184770,751453,22330,687133,320326,327955,1008783,197275,344008,789168,662235,1012640,672535,504611,164948,690914,61872,6335,866960,764977,474966,662995,245412,857070,586772,493595,301923,972744,921804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]