SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525561 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525561 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501372,218874,358003,786928,249940,1035363,22525,1043764,476387,584499,441893,827582,927130,621303,514415,911760,623194,536039,951050,686497,902283,840868,288556,316129,958375,903903,294446,274670,341043,154649,296615,888424,732272,512209,539342,904326,968153,640419,600978,371716,387532,627101,971912,113800,416216,735409,374186,399490,792952,605162,482095,927175,983794,246605,143424,483663,904577,382112,73367,544867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]