SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567916 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567916 [ RunTime:0.002958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148859,789414,1019811,126150,988853,429654,791562,512386,818940,632659,245464,881148,809081,748954,17558,260614,656922,265890,852023,410809,329705,590060,315653,600267,279512,393083,825933,741776,958250,163079,939388,725496,954625,985351,493015,459171,211726,987084,1011259,772742,1001713,287404,360371,823221,180403,492479,883829,1031014,116831,93035,684165,1017343,106320,830654,607863,287088,455128,639275,708777,205041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]