SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002024s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180276 LIMIT 1 [ RunTime:0.001042s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180276 [ RunTime:0.004004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428080,933115,951183,479042,441750,279618,898850,469878,141287,676496,839564,164652,327594,173396,411693,642795,730939,826707,328770,419204,488239,230061,130709,907966,652623,600910,46758,75246,3912,745341,234340,336173,342972,353954,1010981,416733,909352,776561,909645,430543,465598,1048286,1005425,295042,575225,344021,797283,59412,948599,36595,39987,568427,442047,270196,357866,439967,362403,152028,7599,606562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001249s ]