SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504712 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504712 [ RunTime:0.002122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629261,642756,963490,379612,962057,419796,975800,980434,410712,713036,959370,461408,23117,1039475,276024,991088,14898,532768,558308,158116,671051,911761,968443,946391,402724,866277,832575,721704,456346,668510,754037,665893,244419,507339,414087,636182,922472,787164,765399,570687,416117,82325,25123,811087,731820,99431,514423,946203,905176,473356,735342,619158,6454,232906,75236,575915,832577,734795,836972,845888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]