SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031511 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031511 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49862,693519,1021127,776414,1029491,476253,667916,1042160,794953,18649,424440,112206,374343,51331,247961,392055,611962,233009,897513,61834,235077,385175,195717,296712,647216,541815,476327,655167,757452,483237,118214,551833,312268,734444,437869,923746,302848,474827,527729,743909,296121,136538,35225,333267,858175,397805,691462,697340,290418,44286,221476,44147,823571,1011110,210451,550826,796586,206869,359524,174297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003964s ]