SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003892s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532812 LIMIT 1 [ RunTime:0.002273s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532812 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997372,615099,1024752,126284,160286,844556,150348,37157,121486,585123,520271,307537,531834,632971,206699,101923,510166,370214,409138,722535,767816,863817,791193,338336,244485,114232,832656,162064,99648,446169,480557,823119,1047604,714763,616414,248115,696631,174733,619082,43662,167218,396097,929808,246337,361566,336565,472974,1803,334311,1001836,496225,533400,688293,331457,515616,272715,202105,738382,732763,767024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001110s ]