SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302081 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302081 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173663,83701,12847,1000635,594309,502409,924079,286911,483688,672567,414297,618938,888771,182502,803292,121958,135387,494176,905622,688165,592893,879026,735787,772714,980808,503060,494768,221687,727253,1037722,972433,86330,837238,514519,110653,386522,665855,1009744,722498,995480,915077,949788,360818,1044742,51214,1026359,537566,615199,43969,180824,44018,113021,961947,568973,366811,774231,1010346,84999,76158,625668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]