SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410648 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410648 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252970,771915,312904,598307,512795,1018729,675469,312136,999540,495955,868902,478450,287259,144622,461606,366022,382030,272760,771237,483065,469031,624759,884136,374822,16618,370329,362492,601412,122137,1008994,157815,314559,1046525,570207,360074,573927,363074,318184,453617,229977,735471,150088,393966,270886,221863,1028555,852769,693532,705450,104894,482775,542786,941383,867068,938681,984714,921132,727955,1003504,862062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]