SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533213 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533213 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533490,554339,369448,418793,783630,42678,265838,210269,94827,926698,757934,459776,640861,358308,394551,563656,410481,92281,1030061,880991,405423,361119,477365,763735,344200,65112,899019,135106,669256,868048,300542,744520,839497,130739,778698,333137,968692,309353,1025561,427939,522433,759707,734121,221656,4478,760343,321880,213729,807689,27941,120821,614155,693502,328654,639742,740199,505400,123621,143130,404329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]