SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401215 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401215 [ RunTime:0.002448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144681,304480,856375,491338,284338,588123,681557,920053,941352,411394,153387,862583,837250,583905,279666,1003798,430793,568713,1006213,57735,765324,562609,731024,181595,131638,959370,479709,640637,920991,622693,97507,695803,133528,40273,942619,786855,276920,970236,54381,675146,2782,981827,927837,111032,83617,829470,207902,122689,385699,727185,722259,490453,886388,142899,593277,1028608,82517,1025156,590294,107086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]