SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199812 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199812 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440425,234117,739358,184306,809185,261715,371728,874816,755927,489976,544409,555195,822264,913511,628036,649816,916295,183534,288802,628209,598284,514284,218443,912878,472680,110012,664110,583443,905634,30286,831425,868375,841719,830328,151999,990810,494016,424405,354723,74199,446633,326199,400462,781958,812062,27884,848919,712563,601114,830044,571562,67315,541121,33045,27611,181580,853651,790096,710579,466753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]