SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003845 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003845 [ RunTime:0.002523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585961,1016122,415599,961183,915823,1029024,172493,790222,450500,339181,212663,274062,711281,495236,135563,756066,576792,618948,834078,285109,740006,999453,774423,15765,1002129,1040988,319897,764844,1004557,467125,120292,8314,809357,159384,354209,327298,415403,648644,662218,918526,390735,73773,546385,611679,732312,446973,877913,785350,814313,988425,807973,146423,788368,794567,59707,760907,195481,800468,279121,475939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]