SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017063 LIMIT 1 [ RunTime:0.001248s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017063 [ RunTime:0.005022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29329,165943,984359,944114,185702,211677,921380,851308,1001182,894293,903587,290142,158216,922057,760655,919821,123912,358021,182478,851511,639953,886451,340251,481729,671839,144892,611498,914652,77788,460743,614148,277555,392066,944912,455675,981212,766633,856773,799227,193668,386983,965936,288288,622996,170652,456235,1015369,55954,502589,246315,122351,946978,847586,146232,784536,165201,935248,199952,956856,906886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000994s ]