SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522911 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522911 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38723,968828,22581,671805,769105,993979,852136,288629,686771,986739,885670,429066,307355,523949,776463,973304,365963,275271,933883,39429,747821,636332,752370,695616,1028292,151739,444405,837984,552532,197080,185236,780199,405474,318966,725263,741979,556235,671890,397767,679863,384645,505732,957721,604582,103299,22721,629071,486860,192892,111645,58816,337146,1028918,720257,243141,166094,479343,1023063,433446,913633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]