SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284521 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284521 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108599,715296,631000,801548,637992,443078,590462,42944,518445,447712,364295,441846,319703,131931,460759,837181,1039280,2171,335649,18055,360815,754015,140660,816718,613583,115317,399580,258483,314926,725881,345592,624291,969683,935794,754793,82088,598187,41417,18246,704863,500199,703488,141789,515928,103749,910155,671757,371409,957674,724143,168519,970334,312011,896697,513974,723927,366162,558523,128702,888071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]