SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310060 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310060 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543034,734122,231870,180355,301531,117804,781026,37578,954318,605517,56968,155510,445375,556746,715619,32609,52227,590549,323671,688171,156115,384246,82191,252128,536211,161703,328942,134845,892499,240062,280177,584976,697248,230194,107387,845768,165424,397130,251116,139611,817417,108988,948520,595422,353123,992992,594718,733138,91999,588048,833616,584195,863997,909584,247110,599081,654923,605037,149550,830165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]