SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313171 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313171 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136153,771053,434215,748558,496505,431636,596921,146531,888317,973058,657132,479247,871962,12728,936390,982668,333805,8387,351319,135217,581182,350230,996334,64218,553391,672814,451367,544253,41160,650809,819542,501285,383932,765341,598353,390265,71981,475294,760929,876473,1039658,216439,108525,310582,516858,261679,672626,911633,957964,516301,845834,890410,146567,202296,502235,959556,983470,717089,1029772,585503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]