SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541529 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541529 [ RunTime:0.002879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035795,33215,786357,338449,989397,836488,150719,920340,548278,256069,809865,78188,1018642,963755,946569,203497,664924,386434,496908,938277,626615,544776,19418,676319,204343,941402,290092,742921,287990,788056,486767,885021,420643,698236,972000,16964,6555,375378,648903,476905,119605,509820,755635,250148,50770,703644,354688,655309,635292,750112,427189,343928,816700,518119,397012,445168,146850,944259,268583,14747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]