SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503102 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503102 [ RunTime:0.002531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924108,422383,1046053,389138,569872,270336,855845,901580,893870,249508,43112,419429,607602,827657,1041403,973583,118394,390103,965435,464524,716110,874698,770134,762375,203450,123616,69135,409751,115215,534365,638252,22971,144707,343857,22555,171409,87147,338645,668909,796545,590935,695763,483837,907725,1026255,425080,31308,778928,980923,96412,62127,36530,276003,147988,835943,96992,642845,669170,338561,687412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]