SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574513 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574513 [ RunTime:0.002994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861792,641216,114738,802581,962272,351514,395290,764712,60430,610241,1016806,77300,165391,555047,369805,47783,726249,851607,370739,550153,148064,535742,398566,858977,592773,524745,198735,30652,1012129,938894,868085,211238,719600,361348,418680,729298,988823,917403,884171,485274,594591,1027004,495410,641303,919856,690293,499717,63051,1023511,100305,637497,949522,902082,189118,151151,292698,673695,974046,803172,320073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]