SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269071 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269071 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372204,138500,697700,133831,872990,420037,203516,642284,39762,298365,987935,400885,297104,185063,230444,891330,224742,921699,127712,892035,109615,182974,421415,684745,103443,220536,804743,608142,667957,250999,465691,354272,928738,886783,904587,346006,117398,259214,775918,442918,737449,125835,395323,726472,273157,52454,411465,711562,701547,961835,374291,574510,1041499,538348,96761,839822,1018452,492131,975264,120284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]